Skip to main content

Create Right Join in Pipeline.

Introduction​

The RIGHT JOIN combines data from two or more tables. The RIGHT JOIN clause starts selecting data from the right table and matching it with the rows from the left table. The RIGHT JOIN returns a result set that includes all rows in the right table, whether or not they have matching rows from the left table.

From this document, you will learn how to create the Pipeline, which contains the right join, here the right join connects the multiple tables to make the Pipeline.

Prerequisites​

To Schedule a Pipeline, you need working Parameter Datasets(JDBC) and a list of tables and views.

Objective​

How to Create Right join in Pipeline.

Download Pipeline.zip file from the link given Pipeline.zip

Follow steps to create Right-join Pipeline in AIV:-

Login to the AIV application with valid user credentials.

Go to Master Data > Dataset section from the Hamburger menu.

Docusaurus Slash Introduction

Go to the Dataset section, Click on Create Pipeline from the bottom menu bar. As shown in the figure below:

Docusaurus Slash Introduction

Once you click, you can see a blank create pipeline window as in the below image:

Docusaurus Slash Introduction

Enter the Following detail in the Pipeline dialog box:

Name: Right Join

Source: aiv-mapping

Expand tables from the left side table view, As shown in the figure below:

Docusaurus Slash Introduction

Drag and Drop the OFFICE table from the Table list to the Right side diagram box, then select all the columns of the OFFICE table, click on submit button.

Docusaurus Slash Introduction

After submitting, the diagram box will look like the figure below:

Docusaurus Slash Introduction

Drag and drop the CUSTOMER table from the left table menu to the right diagram box. Select all the columns from the CUSTOMER table, then click the submit button, as shown in the figure below:

Docusaurus Slash Introduction

After adding CUSTOMERS and OFFICES from the table list, the diagram box looks like the figure below:

Docusaurus Slash Introduction

Drag the COUNTRY column from Offices to Customers, as shown in the figure below:

Docusaurus Slash Introduction

Click on the join between two tables, to add Pipeline configuration. The Pipeline configuration control box will open, Select the Right Join radio button and click on Submit button, as shown in the figure below:

Docusaurus Slash Introduction

The Connection between the two tables will look as shown in the figure below:

Docusaurus Slash Introduction

Click on Submit to save the pipeline.

The pipeline is run in the Adhoc Analysis.

Go to Documents > Adhoc Analysis section from Hamburger menu.

In Adhoc Analysis click on the + icon to create a new Analysis, as shown in the figure below:

Docusaurus Slash Introduction

When you click on create Analysis then the Analysis Selection dialog box will open, as shown in the figure below:

Docusaurus Slash Introduction

Enter the following details in Analysis Section:

Dataset: Right Join (select the Pipeline, which you are created)

The two tables will get load the left side box of Pipeline view, Now expends the OFFICES table.

Drag and drop TERRITORY column from OFFICES to Rows, Drag and drop a COUNTRY column from OFFICE and Put it in Column box, Drag and drop the POSTAL CODE column from Customers to Values box (Select count in Type), as shown in the figure below:

Docusaurus Slash Introduction

Click on Preview Button it will show the output and after the preview click on Cancel Button it will show the screen as follows:

Docusaurus Slash Introduction

Click on Save asDocusaurus Slash Introduction icon for saving the Analysis, it will show the screen as below:

Docusaurus Slash Introduction

Give the name of Analysis.

Name: Left Join Pipeline and Select the folder where you want to save Analysis, as shown in the figure below:

Docusaurus Slash Introduction

Click on Save As button to save Analysis.

👇More features of AIV are as follows:​

Pipeline Inner Join​

Pipeline Left Join​

Pipeline Language Parameter​